11. Quiz: Combining Data

To combine two sheets with different columns on a primary key - foreign key match, and keep all of the rows from one sheet but only matching rows from the other sheet.

To combine two sheets with different columns on a primary key - foreign key match, and keep all of the rows from both sheets even if they don't match.

To combine two sheets with different columns on a primary key - foreign key match, and keep all of the rows from both sheets only if they match.

To combine two sheets stacked on top of one another that have all the same columns.

INNER JOIN

UNION

FULL OUTER JOIN

LEFT JOIN